CREATE EXTERNAL TABLE jms_ods.`metadata_real` (
  `dag_id` string 
  ,`root_dag_id` string
  ,`is_paused` int
  ,`is_subdag` int
  ,`is_active` int
  ,`last_parsed_time` string
  ,`last_pickled` string
  ,`last_expired` string
  ,`scheduler_lock` int
  ,`pickle_id` int
  ,`fileloc` string
  ,`processor_subdir` string
  ,`owners` string
  ,`description` string
  ,`default_view` string
  ,`schedule_interval` string
  ,`timetable_description` string
  ,`max_active_tasks` int
  ,`max_active_runs` int
  ,`has_task_concurrency_limits` int
  ,`has_import_errors` int
  ,`next_dagrun` string
  ,`next_dagrun_data_interval_start` string
  ,`next_dagrun_data_interval_end` string
  ,`next_dagrun_create_after` string
)COMMENT 'airflow 中dag表数据'
PARTITIONED BY (
  `dt` string COMMENT '创建日期 (yyyy-MM-dd)')
stored as parquet
location '/dw/hive/jms_ods.db/external/metadata_real'
